https://store-images.s-microsoft.com/image/apps.907.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.d4326de0-20a2-47f6-9006-9b10560434e4.1fe8a719-0278-4817-94a7-6e0665e76d4a

Email Any Report

par dataoutput

Generate and email any reports with dynamic date periods using Job Queue.

https://dataoutput.sg/email-any-report

Using Job Queue to generate and email any report with dynamically calculated dates.

  1. Replace the value for 'StartingDate' and/or 'EndingDate' with the keyword Today in the XML.
  2. Today will be the date of the job queue execution.
  3. Combine with the standard functionality of the date formula.

weekly report with recurring job queue running every Friday.
  • StartingDate = Today-5D
  • EndingDate = Today

monthly financial report with recurring job queue running every first day of the month.
  • StartingDate = Today-1M-CM (first day of the previous month)
  • EndingDate = Today-1D (last day of the previous month)

Attach the email scenario 'Email Any Report' to the preferred email account if required.

Vue d’ensemble

https://store-images.s-microsoft.com/image/apps.7084.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.d4326de0-20a2-47f6-9006-9b10560434e4.8e4beda2-0a03-47b1-b2d7-c4e3b2c62f75
/staticstorage/4a5d0dd/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.35369.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.bb86916f-a860-4d91-ad35-075a9abd8302.ec116f20-e3e5-4d5f-88b0-9b068098b3c2
https://store-images.s-microsoft.com/image/apps.18133.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.bb86916f-a860-4d91-ad35-075a9abd8302.c21684e8-4408-4c7a-a2ed-21c0d3dae12d
https://store-images.s-microsoft.com/image/apps.53578.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.bb86916f-a860-4d91-ad35-075a9abd8302.d07c99a9-a88f-4898-96ad-aae616dffc4e
https://store-images.s-microsoft.com/image/apps.46473.ff7e3dc6-22f4-44b8-9ebd-58bb66bfba99.bb86916f-a860-4d91-ad35-075a9abd8302.6fe4175e-ffd7-4a02-aa04-db4d5c257337